ActiveData Property

       

Returns a PivotData object that represents the data in the active PivotTable list.

expression.ActiveData

expression   Required. An expression that returns a PivotTable object.